Schedule of Values Tab

As you work on a contract, you often need to see the quantity or value of a line item claimed against a component, so you can progress the contract. A component is used in InEight Plan and InEight Progress to divide a cost item into manageable and identifiable parts, so they are easy to track. The schedule of values lets you see the totals claimed by a component. You can also use the totals to reconcile a vendor invoice with the contract line items.

The Schedule of Values tab shows the details of line item parts. Each part is made up of a description, schedule quantity, unit of measure, unit price, schedule value, and WBS code. You can choose whether to have the schedule item available to use in Plan and Progress or to hide it from those applications. The Schedule of values page lists all of the schedule items for the contract. A warning shows if the schedule value exceeds the Net price of the line item.

To add a schedule of values, click the Add schedule of value icon on the Schedule of values tab.

Add schedule item

When you add a new schedule item, the Add schedule of value slide-out panel opens, where you can fill in the pertinent information for the schedule item.

  Field Function
1 Contract line item ID Select the line item associated with the schedule of value item.
2 Description Free text entry field to describe what the schedule of value item is.
3 Schedule quantity The total quantity of the item. The quantity must be greater than zero.
4

UoM

Select the unit of measure for the schedule of value item. The unit of measure can be different from the unit of measure for the line item.
5 Unit price The unit price, in the currency of the contract, of the schedule of value item. The unit price is automatically calculated when the schedule value or schedule quantity is updated. A negative number can be entered for the unit price when an item has a negative value.
6 Schedule value Contract calculates the schedule value based on the quantity and unit price.
7 WBS code The WBS code assigned to the line item.
8 Hide in plan and progress Select the box to hide the schedule item from Plan and Progress. Deselect the box to track the schedule item as a contract component in Plan. If an item has a value other than zero in Plan and Progress, you cannot deselect this check box. If you have made a mistake, you must go to Plan or Progress, and then edit the item there. After it is edited, you can deselect the check box. A schedule item that is hidden in Plan and Progress can be claimed directly from Contract.
9 Custom fields The contract-level custom fields.

You can also add a schedule of value item from the Line items register. Any line item type except the Limit line item type can be copied. To copy a line item from the Line items register to the schedule of values, select the line item, and then expand the Copy icon. You can then select To schedule of values. A notification shows that the line item has been added to the schedule of values. The following columns are copied with the line item:

  • Line Item ID

  • Description

  • UoM

  • Quantity

  • Unit Price

  • WBS code

  • Custom fields

The Hide in Plan/Progress field in the schedule of values defaults to Yes. You must manually fill in the remaining fields. The line item is automatically associated to the schedule of values.

If the line item had been deleted or closed, the line item is copied, but the line item ID is left blank.

You can use the import and export feature to set up and maintain a large schedule of values.

Schedule of value items register

After you add a schedule of values item, Contract adds a Schedule item ID and adds it to the schedule of value items register. The register lists all schedule items for the contract. The schedule of values grid has sections for schedule of values details, Contract claims, component progress, and summary progress. Arrows in the column headers let you collapse or expand the section. Multiple sections can be collapsed. The first section, which includes the Schedule line item ID, Contract line item ID, and Description cannot be collapsed. You can click the double arrow in the first section to collapse the rest of the sections.

The bottom of the grid shows the total number of items and the total number of selected items. To see only the selected items, click View selected. Click Clear selection to deselect all items. The Go to Schedule ID link helps you quickly find Schedule items that are not visible on the page.

You can rearrange the columns within a section using the Column Selector Builder. To open the Column Selector Builder, click Manage columns. The Available columns section shows all columns that are available for each section. To add a selection or column, select it, and then move it to the Selected Columns section. To remove a section or column, select it, and then move it to the Available columns section. Click Save to apply the changes. You can also rearrange sections from the Column Selector Builder dialog box. To move a section, select it, and then use the arrows to move the section up or down. You cannot add columns to the first section in the grid. You cannot move columns between sections.

You can search for specific available or selected columns. For example, you could search for value Claimed, and the search results show all columns called Value Claimed in all sections.

Schedule of values details

The Schedule of value items section shows the schedule quantity, component quantity, unit of measure, unit price, schedule value, WBS code, and whether the item is hidden in Plan and Progress.

If the schedule values for a line item exceed the net price of the line item, all schedule items for that line item are marked with a warning icon in the Schedule values column. To keep totals in sync, you must change the number in the line item or the schedule items. If a schedule item has been claimed in Plan or Progress, you cannot delete the schedule of values item. You can update the item, and then the update goes to Plan or Progress.

If a schedule item is not hidden in Plan and Progress, the Component quantity column shows the Component quantity from Plan. If the value is modified in Plan by splitting the contract component, a blue dot shows next to the quantity to indicate the component quantity does not match the schedule quantity.

If there is no quantity claimed, you can delete a schedule of values item that is not hidden from Plan and Progress.

The total schedule value amount shows at the bottom of the section.

Contract claims

The Contract grid section shows the quantity and value claimed in Contract. The total amount claimed in Contract shows at the bottom of the section. If the current date is not between the valid from and valid through dates of the associated line item, an error icon shows in the Contract line item ID column of the register, and no claims can be made from associated schedule items.

See Claim schedule items from Contract for information about claiming in Contract.

Component progress

The Component progress grid section shows claims that were made in Plan and Progress. Click on a link in the Quantity claimed or Value claimed column to go to quantity tracking in Plan.

The total amount claimed in Contract shows at the bottom of the section.

Summary progress

The Summary progress grid section shows the total of claims made in Contract and in Plan and Progress.

Field Function
Quantity claimed The total number of items claimed.
Value claimed The total amount (that is, the quantity multiplied by the unit price) claimed.
% Complete The percent of the schedule value that has been claimed.
Quantity remaining The number of items that remain to be claimed (that is, the schedule quantity minus the quantity claimed).
Value remaining The value that remains to be claimed (that is the schedule value minus the value claimed).

Date fields in the toolbar let you narrow the dates that components were claimed.

The total value claimed, percent complete, and value remaining show at the bottom of the section.

Payment claims

The Payment claims grid section shows the quantities and values used in payment claims. For information about Payment claims, see Payment claims.

Field Function
Vendor quantity The quantity of the claim for a vendor.
Vendor value The value of the claim for a vendor.
Certified quantity The quantity of claims that have been certified.
Certified value The value of claims that have been certified.
Certified delta The difference between the vendor value and the certified value.
Pending quantity The quantity of claims that are pending certification.
Pending value The value of claims that are pending certification.
Pending delta The difference between the vendor value and the pending value.